 /****** Object:  Stored Procedure TerritoriesGetList    Script Date: Monday, December 10, 2007 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spTerritoriesGetListByCountry]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [spTerritoriesGetListByCountry]
GO

CREATE PROCEDURE spTerritoriesGetListByCountry	
	@CountryId int
AS

SELECT
	[Territories].[TerritoryID],
	[Description],
	[CountryID]
FROM
	 [Territories] 
WHERE  CountryID=@CountryID

GO

	
